SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW [dbo].[TMEMPR]  
As   
SELECT [CO_EMPR], [DE_NOMB], [DE_NOMB_CORT], [CO_GIRO],   
  [DE_DIRE], [CO_UBIC_GEOG], [CO_PAIS], [NO_DEPA],   
  [NO_PROV], [DE_CODI_POST], [NU_TLF1], [NU_TLF2],   
  [NU_FAXS], [NU_RUCS], [DE_DIRE_WEBS], [DE_DIRE_MAIL],   
  [CO_MONE_NACI], [NU_CERT_INSC], [NU_REGI_PUBL], [NU_LICE_MUNI],   
  [NO_REPR_LEGA], [NO_GERE_GRAL], [NV_INFO_OSER], [NV_QUIE_OSER],   
  [ST_PLAN], [ST_CONT], [ST_TESO], [ST_LOGI], [ST_VENT],   
  [ST_PROD], [ST_ACTI], [ST_PRES], [ST_SIS1], [ST_SIS2],   
  [ST_SIS3], [ST_SIS4], [ST_SIS5], [DE_RUTA_LOGO] AS DE_LOGO, [TI_SITU],     
  [CO_USUA_CREA], [FE_USUA_CREA], [CO_USUA_MODI], [FE_USUA_MODI]   
FROM [OFISEGU].[dbo].[TMEMPR]

GO
